﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CoVanHocTapData.Entities;

namespace CoVanHocTapData.Interface
{
    public interface IChuanDauRaRepository
    {
        float ChuanToeicCua(string maSV);

        float SoHocPhanGDQPDaHTCua(string maSV);
        float SoHocPhanGDTCDaHTCua(string maSV);

        IQueryable<ChuanDauRa> LayChuanDauRaTinChi(string nganh,int nienKhoaID, string heDaoTaoID, int loai);
        IQueryable<ChuanDauRa> LayChuanDauRa(string nganh, int nienKhoaID, string heDaoTaoID);

        void ThemChuanDauRa(ChuanDauRa item);
        void ThemChuanDauRa(List<ChuanDauRa> ChuanDauraList);
        void UpdateChuanDaura(ChuanDauRa item);
        void XoaChuanDauRa(ChuanDauRa item);

        bool KiemTraChuaDauRa(ChuanDauRa item);
        bool KiemTraChuanDauRa(string heDaoTaoID, string nganhID, int nienKhoaID);

        IQueryable<NganhDaoTao> LayNganh();
        IQueryable<HeDaoTao> LayHeDaoTao();
        IQueryable<NienKhoa> LayNienKhoa();

        int ChuanDGRL(string maNganh, string maHeDaoTao, int maNienKhoa);
        ChuanDauRa LayChuanDauRaTheoID(int id);
    }
}
